SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlformgeneral
AS
SELECT DISTINCT 
                      TOP 100 PERCENT dbo.u_fg_00_varios.Id, dbo.u_cui.cui, dbo.u_jurisdiccion.jurisdiccion, dbo.u_fg_00_varios.superficie AS SuperficieFG, 
                      dbo.u_fg_00_varios.cantTotalConstruciones, dbo.u_fg_00_varios.observaciones, dbo.u_tp_respuesta.descripcion AS ActualizarPlanos
FROM         dbo.u_fg_00_varios INNER JOIN
                      dbo.u_cui INNER JOIN
                      dbo.u_jurisdiccion ON dbo.u_cui.idjurisdiccion = dbo.u_jurisdiccion.idJurisdiccion ON dbo.u_fg_00_varios.idCui = dbo.u_cui.Id INNER JOIN
                      dbo.u_tp_respuesta ON dbo.u_fg_00_varios.idcorrespondeplanos = dbo.u_tp_respuesta.Id
GO
GRANT SELECT ON  [dbo].[vwlformgeneral] TO [Cenie]
GO
